SQL Server Administration User Guide

Overview

This DEX Pack is used to monitor SQL servers. It provides a detailed inventory of these servers as well as many performance metrics. Use this DEX Pack to identify system issues affecting your enterprise’s SQL servers.

SQL Server Inventory and Overview

View an inventory and a general health overview for SQL servers.

SQL Server Performance

View detailed health information for SQL servers. Determine which system issues and other metrics are most strongly impacting server performance.

SQL Server Inventory and Overview

Hardware Overview

If your enterprise has any SQL servers that are not listed as a Server in SysTrack, you may want to set the Only include Servers drop-down to No.

Data from SQL Server Express is excluded by default because that edition is often used for tests or practice.

Health Score shows the percentage of time where productivity was not negatively impacted by system issues. System issues can include a variety of factors such as latency, CPU utilization, and disk utilization. In general, a lower Health Score indicates that a server is affected by system issues more often. This score is an average for a server during the past 30 days.

For example, consider a server with an average Health Score of 85. This server is negatively impacted by system issues for 15% of its active time. If this server is active for 10 hours a day, then it is usually impacted by system issues for 1.5 hours each day.

Memory Utilized, CPU Utilized, and Disk Utilized all indicate an average percent utilization across the past 30 days.

Double-click any of the systems in this table to more closely investigate that system in Resolve.

Inventory Overview (Selected Group)

This graph shows the number of instances and databases created for different editions of SQL Server. This graph only includes data from the Group selected in Hardware Overview.

Database Details (Selected System)

This table shows additional details about the databases created for the selected system.

SQL Server Performance

Health Overview

This Health Score data mirrors the data from the Hardware Overview pane, except that this data is collected from the past week.

Top 5 Health Impacts (Selected System)

This graph shows which factors have the highest negative impact on the selected system’s Health Score. Hover over a category to see the amount of active time impacted by that system issue. These impact minutes are summed from the past 30 days.

Health Trend Comparison (Selected System vs Average)

This graph compares the Health Score of the selected system to the average Health Score for the Group selected in Health Overview. This data is from the past 30 days.

Health Trend Details (Selected System)

This graph shows the amount of time the selected system was impacted by system issues each day. Troubleshoot these issues in Resolve by double-clicking the selected system in Health Overview.

Additional Performance Metrics (Selected System)

This table shows various performance metrics for the selected system over the past week.

Logical Connections and User Connections are a sum of the data from that day. Errors, Full Scans, Index Searches, and Batch Requests are all an average of that data per second. Buffer Cache Hit Ratio is a daily average. Page Life Expectancy is measured once each day.

To view more detailed data for any of these metrics, use Performance Metric Trends (Selected System). Troubleshoot these issues in Resolve by double-clicking the selected system in Health Overview.

Performance Metric Trends (Selected System)

This graph shows data for the selected performance metric and system over the past week.